package PRSystem_Service;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Scanner;

import jhlee42.model.SungJuk2VO;
import PRSystem_Main.PRSystem_connection;
import PRSystem_VO.PRSystem_PerformanceVO;

public class PRSystemPerformanceServiceImpl implements
		PRSystemPerformanceService {

	@Override
	public void newPerformance() {
		
		Connection conn =null;  
		PreparedStatement pstmt = null;
		ResultSet rs = null; // select 문 실행시에 만!!
		
		String result="";
		String sql="insert into SUNGJUK(perno.nextval,name,kor,eng,mat,tot,avgs,grd)values(sjno.nextval,?,?,?,?,?,?,?)";
		Scanner sc = new Scanner(System.in);
		
		//Scanner sc = null;
		System.out.println("공연 정보를 입력하세요..");
		System.out.println(",순으로 입력하세요");
		PRSystem_PerformanceVO pr = new PRSystem_PerformanceVO (sc.next(), sc.next(), sc.next()); 

		
		
//		perno number(3) constraint performance_perno_pk primary key,
//		title varchar2(50) constraint performance_title_nn not null,
//		img Long Raw,
//		price number(10) constraint performance_price_nn not null,
//		actor varchar2(50),
//		summary varchar2(50),
//		period varchar2(25) constraint performance_period_nn not null,
//		dates varchar2(10) constraint performance_date_nn not null,
//		time varchar2(10),
//		pno number(3)
		
		
		
		
		
		PRSystem_connection conn_strart_object = new PRSystem_connection();
		try {
			conn = conn_strart_object.makeConn();
			
			
			
			
			
			
			
			
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
		
		

	}

	@Override
	public void readPerformance() {
		// TODO Auto-generated method stub

	}

	@Override
	public void readOnePerformance() {
		// TODO Auto-generated method stub

	}

	@Override
	public void modifyPerformance() {
		// TODO Auto-generated method stub

	}

	@Override
	public void removePerformance() {
		// TODO Auto-generated method stub

	}

}
